[dbo].[UnofferedCustomerExperience]

Property	Value
Created	10:31:42 AM Tuesday, March 02, 2010
Last Modified	1:17:35 PM Thursday, February 23, 2012

Property

Value

Created

10:31:42 AM Tuesday, March 02, 2010

Last Modified

1:17:35 PM Thursday, February 23, 2012

Name	Data Type	Max Length (Bytes)
UnofferedCustomerExperienceKey	uniqueidentifier	16
ExperienceDefinitionKey	uniqueidentifier	16
UnofferedCustomerExperienceGrade	nvarchar(50)	100
CompletionDate	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

UnofferedCustomerExperienceKey

uniqueidentifier

ExperienceDefinitionKey

uniqueidentifier

UnofferedCustomerExperienceGrade

nvarchar(50)

100

CompletionDate

datetime

	Name	Columns	Unique
	PK_UnofferedCustomerExperience_UnofferedCustomerExperienceKey	UnofferedCustomerExperienceKey
	IX_UnofferedCustomerExperience_ExperienceDefinitionKey	ExperienceDefinitionKey

Name

Columns

Unique

PK_UnofferedCustomerExperience_UnofferedCustomerExperienceKey

UnofferedCustomerExperienceKey

IX_UnofferedCustomerExperience_ExperienceDefinitionKey

ExperienceDefinitionKey

Name	Columns
FK_UnofferedCustomerExperience_CustomerExperience	UnofferedCustomerExperienceKey->[dbo].[CustomerExperience].[CustomerExperienceKey]
FK_UnofferedCustomerExperience_ExperienceDefinition	ExperienceDefinitionKey->[dbo].[ExperienceDefinition].[ExperienceDefinitionKey]

Name

Columns

FK_UnofferedCustomerExperience_CustomerExperience

UnofferedCustomerExperienceKey->[dbo].[CustomerExperience].[CustomerExperienceKey]

FK_UnofferedCustomerExperience_ExperienceDefinition

ExperienceDefinitionKey->[dbo].[ExperienceDefinition].[ExperienceDefinitionKey]

SQL Script

CREATE TABLE [dbo].[UnofferedCustomerExperience]
(
[UnofferedCustomerExperienceKey] [uniqueidentifier] NOT NULL,
[ExperienceDefinitionKey] [uniqueidentifier] NOT NULL,
[UnofferedCustomerExperienceGrade] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CompletionDate] [datetime] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[UnofferedCustomerExperience] ADD CONSTRAINT [PK_UnofferedCustomerExperience_UnofferedCustomerExperienceKey] PRIMARY KEY CLUSTERED ([UnofferedCustomerExperienceKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UnofferedCustomerExperience_ExperienceDefinitionKey] ON [dbo].[UnofferedCustomerExperience] ([ExperienceDefinitionKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UnofferedCustomerExperience] ADD CONSTRAINT [FK_UnofferedCustomerExperience_CustomerExperience] FOREIGN KEY ([UnofferedCustomerExperienceKey]) REFERENCES [dbo].[CustomerExperience] ([CustomerExperienceKey])
GO
ALTER TABLE [dbo].[UnofferedCustomerExperience] ADD CONSTRAINT [FK_UnofferedCustomerExperience_ExperienceDefinition] FOREIGN KEY ([ExperienceDefinitionKey]) REFERENCES [dbo].[ExperienceDefinition] ([ExperienceDefinitionKey])
GO